My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
-
Re: Using % Formula of Summary level
Hi @Buckeye1497, Try this formula: {quantity}/NULLIF(TO_NUMBER({item.custitem_containerquantity}),0) When using this field in a formula/computation, you need to convert the value to a number first si…1 -
Re: TOP CONTRIBUTOR FOR AUGUST 2022!
WOW! 31 Reactions, 15 Accepted Answers & 33 discussions participated in! Congratulations, @Gaurav_NS! 👏1 -
Re: Custom Total Amounts on Saved Search
Hi @Tybrneryan, Glad to have you with us today! Try these formula: Sum of Positives: CASE WHEN {amount} > 0 THEN {amount} END Sum of Negatives: CASE WHEN {amount} < 0 THEN {amount} END Hope thi…1 -
Re: Saved Search | Show Built Qty and Used in Build Qty in Work Orders
Hi @GLL, The sample I showed is just a simple search with the Criteria Type = Work Order. The Results fields are: Document Number Item * (This represents Main Line) Quantity Quantity Fulfilled/Receiv…1 -
Re: AE:MIN and MAX Date on Expected Receipt Dates
Hi @OliverK, Great to see you again and happy Friday to you as well! I think MIN/MAX function doesn't matter much in your formula since you have it set to "last order by". so it will o…1
